limits of float8
От | Stuart Rison |
---|---|
Тема | limits of float8 |
Дата | |
Msg-id | v04020a04b3a107be9d35@[128.40.242.190] обсуждение исходный текст |
Список | pgsql-general |
Dear all, What are the limits of float8? The user guide says variable-precision, 14 decimal places range but I'm not sure how that translates to a minimum value. I'm asking because I'm storing probability scores (range 0 to 1) with some scores very small indeed. The very small scores are all entered in scientific notation. From experimentation, the smallest value I seem to be able to enter is around 2.225e-308. Is this 'correct'? This is PG 6.4 compiled with cc under Irix 5.3. Cheers, Stuart. +-------------------------+--------------------------------------+ | Stuart Rison | Ludwig Institute for Cancer Research | +-------------------------+ 91 Riding House Street | | Tel. (0171) 878 4041 | London, W1P 8BT, UNITED KINGDOM. | | Fax. (0171) 878 4040 | stuart@ludwig.ucl.ac.uk | +-------------------------+--------------------------------------+
В списке pgsql-general по дате отправления: